??? VLOOKUP / referencing cells

[MarcLewis]

Morning everyone,

I have a spreadsheet where I would like to manually add a figure in column B (which corresponds to a figure in column B of a different sheet within the same workbook) and for columns A & D to autopopulate from columns AO & AP on a different sheet in the same workbook based on Column B's value.

I have attached a copy of my workbook in case this doesn't make sense.

Many Thanks in advance

Demo.xlsx

[benishiryo]

hi MarcLewis. you need to first change Column A to General instead of Text format. then A3 is:
=INDEX('Reference Material'!AP:AP,MATCH(B3,'Reference Material'!B:B,0))

use the same formula in D3, but change the reference to AO:
=INDEX('Reference Material'!AO:AO,MATCH(B3,'Reference Material'!B:B,0))

you could of course use VLOOKUP too. it'll be:
=VLOOKUP(B3,'Reference Material'!B:AO,40,0)

[MarcLewis]

Thank you very much that is exactly what I needed, unfortunately my boss has now requested more info from another tab in my work book
how can I repeat the formula based on the original formula result. can I index match from a cell that is populated from a index match?
many Thanks

[arjoy1123]

Hi,

I have 2 excel files (same format) where I need to grab the "Cost Price" which is in column L from "Ashley format" to column L of "Ashley_1" provided that it should match the "Product Code/SkU" (in column E) of both worksheets. . Everything is in same format

I have attached a sample of my 2 spreadsheet (assuming that it matches the product code/SKU) I have thousands of products in my original worksheet that needs to be done.

Ashley_1.xlsx
Ashley_format.xlsx

Many Thanks!

Arjoy