vlookup or sumproduct with lists

Kmitchell

Active Member
Joined
Feb 27, 2007
Messages
343
Is there a simple way to do a lookup in a list?

For example in column B sits a bunch of codes, and on sheet1A2:A8 sits specific codes I am trying to isolate. I want to throw a formula in column C that says if b2 falls within sheetA2:A8 then give me b2, otherwise give me "non medicaid". I believe there is a simple way to do this...would it be a sumproduct formula?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try

=IF(ISNUMBER(MATCH(B2,'Sheet1'$A$2:$A$8,0)),B2,"non medicaid")
 

Watch MrExcel Video

Forum statistics

Threads
1,109,041
Messages
5,526,416
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top