Compare 1 cell to column of cells returning adjacent cells info?

M

Mr. Fine

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?
 
D

Duke Carey

You are describing the VLOOKUP() function

=VLOOKUP(B6,'Sheet 3'!$J$1:$0$500,6,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup returning wrong results 0
Display contents of adjacent cells 3
search a string as substring and give adjacent values 1
# Value error and how to ignore blank cells 2
Spurious Formula Omits Adjacent Cells 2
Compare cells in different worksheets 3
want to track time while paste value in multiple column of same roe 1
Same =rand() value in two adjacent cells in column 2

Top