| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup or maybe Vlookup
Mike,
Try something like =VLOOKUP(A1, B1:C500, 2, FALSE) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Mike" wrote in message ... I can't get my head around the syntax of a formula for lookup. Formula is in D1 1 have a number in cell A1 I want to find a match for the number in column B and then return the value in column C in the same row as the match was found. Help much appreciated. mh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup or Vlookup? | Excel Worksheet Functions | |||
| About Lookup and Vlookup | Excel Discussion (Misc queries) | |||
| =IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B4),(VLOOKUP(B4,B | Excel Worksheet Functions | |||
| Help with lookup (vlookup) | Excel Worksheet Functions | |||
| Lookup / Vlookup ?? | Excel Programming | |||
Threaded Mode
