| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 1 cell to column of cells returning adjacent cells info?
I want to compare the value in one cell to another column of cells in another
work sheet and once the matching value is found I wan to return a different cells value that is on the same line as the matching cell. Example Sheet 1 value is 34 in B6, so I want it to search Sheet 3 colum J for the value 34 which is found on row 351. When a match is found the value returned needs to be from colum O so this would be O351. Does anybody know how to setup this function? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare 1 cell to column of cells returning adjacent cells info?
You are describing the VLOOKUP() function
=VLOOKUP(B6,'Sheet 3'!$J$1:$0$500,6,0) "Mr. Fine" wrote: I want to compare the value in one cell to another column of cells in another work sheet and once the matching value is found I wan to return a different cells value that is on the same line as the matching cell. Example Sheet 1 value is 34 in B6, so I want it to search Sheet 3 colum J for the value 34 which is found on row 351. When a match is found the value returned needs to be from colum O so this would be O351. Does anybody know how to setup this function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get info from adjacent cells | Excel Worksheet Functions | |||
| Help! Compare one cell against a whole column, report adjacent cel | Excel Worksheet Functions | |||
| function returning SUM of 2 adjacent cols in 2 separate cells | Excel Worksheet Functions | |||
| compare adjacent cells and calculate averages | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Linear Mode
