| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i create an IF func to return values from another spreadshe
Hi
I have done a VLookup and want to return the value in one spreadsheet into another when the vlookup returns a match. Can anybody please help as I am going round in circles. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i create an IF func to return values from another spreadshe
Hi,
Your question isn't clear but this returns a match if there is one or a blank if there isn't =IF(COUNTIF(Sheet2!A2:A12,A1)0,VLOOKUP(A1,Sheet2! A1:B11,2,FALSE),"") Mike "ALF2008" wrote: Hi I have done a VLookup and want to return the value in one spreadsheet into another when the vlookup returns a match. Can anybody please help as I am going round in circles. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i create an IF func to return values from another sprea
Minor corrections with cell references.
The below formula will check whether the entry in Sheet1 cell A1 exists in Sheet2 ColA . If a match is found it would return the ColB value of the corresponding entry from Sheet2. =IF(COUNTIF(Sheet2!A:A,A1),VLOOKUP(A1,Sheet2!A:B,2 ,0),"") If this post helps click Yes --------------- Jacob Skaria "Mike H" wrote: Hi, Your question isn't clear but this returns a match if there is one or a blank if there isn't =IF(COUNTIF(Sheet2!A2:A12,A1)0,VLOOKUP(A1,Sheet2! A1:B11,2,FALSE),"") Mike "ALF2008" wrote: Hi I have done a VLookup and want to return the value in one spreadsheet into another when the vlookup returns a match. Can anybody please help as I am going round in circles. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
| How 2 sum the abs values of several cells w 1 func in XL. | Excel Worksheet Functions | |||
| How 2 sum the abs values of several cells w 1 func in XL. | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
Linear Mode
