ExcelBanter - Formatting cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting cells (https://www.excelbanter.com/excel-discussion-misc-queries/133976-re-formatting-cells.html)

Formatting cells

on in D1 of sheet 2 enter
=vlookup(B1,'Sheet1'!A:B,2,0)

"pblake" wrote:

I hope this makes sense...
I have a sheet in workbook, with column A listing data, and column B listing
the corresponding price.

On another page, I would like to enter data, and have the prices come up.

On page 2, if B1=L5301, I want D1 to pull the price page 1 in the workbook.

All times are GMT +1. The time now is 05:41 PM.