Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question?
do you know how i can lookup value that isn't precise. for example if i
was using a vlookup function is there a way to lookup a value that isn't exact, as if i was looking up "January" but wanted to include cells that contain either January or January '06 or January 2006? thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question?
Hi!
Try this: =VLOOKUP("january*",A5:B10,2,0) Or: A1 = january =VLOOKUP(A1&"*",A5:B10,2,0) Note: if you enter January 06 or January 2006 in a cell Excel will automatically format those entries as DATES and the lookup would fail. You would have to enter those values as TEXT. Biff "hotelmasters" wrote in message ... do you know how i can lookup value that isn't precise. for example if i was using a vlookup function is there a way to lookup a value that isn't exact, as if i was looking up "January" but wanted to include cells that contain either January or January '06 or January 2006? thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question?
thx for the help
"Biff" wrote: Hi! Try this: =VLOOKUP("january*",A5:B10,2,0) Or: A1 = january =VLOOKUP(A1&"*",A5:B10,2,0) Note: if you enter January 06 or January 2006 in a cell Excel will automatically format those entries as DATES and the lookup would fail. You would have to enter those values as TEXT. Biff "hotelmasters" wrote in message ... do you know how i can lookup value that isn't precise. for example if i was using a vlookup function is there a way to lookup a value that isn't exact, as if i was looking up "January" but wanted to include cells that contain either January or January '06 or January 2006? thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question?
You're welcome!
Biff "hotelmasters" wrote in message ... thx for the help "Biff" wrote: Hi! Try this: =VLOOKUP("january*",A5:B10,2,0) Or: A1 = january =VLOOKUP(A1&"*",A5:B10,2,0) Note: if you enter January 06 or January 2006 in a cell Excel will automatically format those entries as DATES and the lookup would fail. You would have to enter those values as TEXT. Biff "hotelmasters" wrote in message ... do you know how i can lookup value that isn't precise. for example if i was using a vlookup function is there a way to lookup a value that isn't exact, as if i was looking up "January" but wanted to include cells that contain either January or January '06 or January 2006? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Excel formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Worksheet Functions | |||
I have a question regarding countif formula. | Excel Worksheet Functions |