formula filling a row from another sheet

K

Kalle

Hi @ all,

want to display in sheet1 columnX the Value of sheet2 ColumnY
if Value Sheet2 ColumnX equals sheet1 columnZ
Rows differ.

In other words:
If on sheet1 A1 is 5 then find on sheet2 in Column D the row where Value is
5, than give me Value of sheet2 Column G of this row.
 
R

Robert McCurdy

=VLOOKUP(A1,Sheet2!D:G,4,0)

Your description of your problem Kalle is the most confusing explanation of VLOOKUP use I have yet seen.


Regards Robert
"u forgot the ! Frank :)"
 

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

My Never ending ARRAY code problems 18
Can I send an email too? 3
Match columns to rows then loop. 2
How to Populate Data from a table to another 0
Sheet to sheet code Type Mismatch 6
Macro to match 2 column values in different sheets 1
Changing Cell Color based upon value on another worksheet 2
Help with Formula 2

Top