Column Returns in different worksheets

  • Thread starter Thread starter CleverTrevor
  • Start date Start date
C

CleverTrevor

I'm trying to return a value where

If

Sheet 1 column A = Sheet 2 Column A then return the value
(true numbers) from Sheet 2 Column B (where sheet 1
column A could have multiple matches in sheet 2 cloumn A)

Thanks in advance.
 
Hi
the following would return the first match fro sheet 2:
=VLOOKUP(A1,'sheet2'!$A$1:$B$1000,2,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

formula for shauna 2
Look up, return value 5
Two colums match return text from another 12
Cross-Referencng numbers between worksheets 3
Excel Reference to text returning "0" value on second column 0
need a macro to append data to a table 3
Lookup value in one column & add the values in adjacent columns 3
vlookup or Match 6

Back
Top