lookup from another sheet in same workbook

[dougmorgan]

Hi All,

This will be bread and butter to all you Excel whizzes , but i'm struggling with it.

i have a sheet called "catalogue" where i need to insert the price that corresponds to the same code from the "data" sheet.
If a new row is inserted into the "data" sheet, the price in the "catalogue" should stay in the same cell that corresponds to the code.

I've tried lookups but without success, the "data" sheets has blank rows but the price is always on the same row as the code.

i think i have inserted an attachment.

Any help appreciated.

Doug

[AliGW]

In C3 on the Catalogue tab:

Please Login or Register  to view this content.

You can make the ranges as long as you like, as long as they are of equal length.

[seawcbee]

Hi there,

In cell C3 on the CATALOGUE sheet, enter this:

=VLOOKUP(A3,DATA!A:K,11,0)

[AliGW]

Hi there,

In cell C3 on the CATALOGUE sheet, enter this:

=VLOOKUP(A3,DATA!A:K,11,0)

Better to make the range in red limited, unless you want to slow the calculation down. Always avoid entire column ranges if you can!

[seawcbee]

AliGW I dont maintain my models, have to build them idiot proof.

Follow on question though, any way to limit the vlookup to the last row that contains data? vlookup(A1,A(Countrows):B(countrows)??

[dougmorgan]

Thanks Guys, appreciate you taking the time to help.

[AliGW]

AliGW I dont maintain my models, have to build them idiot proof.

Follow on question though, any way to limit the vlookup to the last row that contains data? vlookup(A1,A(Countrows):B(countrows)??

I have no idea what your first statement means!

As for the question, I am sure there is a way, but I don't at this moment in time know what it is.

[AliGW]

Thanks Guys, appreciate you taking the time to help.

You're very welcome! Please mark the thread as solved and consider awarding reputation to the participants who helped you.