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

Word macro that can call cells out of Excel for a find and replace 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Adding cells until they are greater than a lookup cell and returning a value 1
Dealing with the error: unable to filter on excel hc home school 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Copy addition formula of non-consecutive horizontal cells 2
Split cells next to 1 cell 1
use month in cell date to sum all relevant cells 2

Top