ST Alpha - "I would use a vlookup with an iserror to correct for ones not in Tab 2." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 158

In response to "excel help" by Truman

I would use a vlookup with an iserror to correct for ones not in Tab 2.

Posted by spamlet Jul 1 '14, 08:14

It gets quite ugly with the nested function, but basically it is:

=if(iserror(vlookup),"N/A",vlookup)

Responses:

yeah i got it to work, - Truman Jul 1, 08:23 1
- this is another thing about IM vs VL or HL: IM can go backwards. VL and HL can't see anything before the lookup column. - peggy ann m Jul 1, 08:28
I have switched almost 100% to INDEX, MATCH because it's faster (returns a range, not a value). - peggy ann m Jul 1, 08:19 1
- My new guy is a big fan of INDEX, MATCH but I haven't gone through to learn it yet. -- nm - spamlet Jul 1, 08:20

Post a message top

Replies are disabled on threads older than 7 days.