Excel inter-relating Worksheet IF functions....

  • Thread starter Thread starter Souljah
  • Start date Start date
S

Souljah

Hi
I have a workbook with a Orders sheet, products sheet (for referenc
on the orders page)

I need a formula to give the price of a product automatically on th
order page by using the Product number.

I can currently do this but I have problems when the product numbe
repeats, It refers to the relative cell on the product page instead o
matching product numbers.
I'm quite new to excel functions so I'm not sure what is needed to mak
this possible...
Here is the formula im using.

=IF(B2=Products!A2,Products!D2, N/A)

Would I need a lookup function to work in tandem with the IF function

Any help is most appreciated
 
Hi
maybe VLOOKUP is what you're lookin for:
=VLOOKUP(B2,Products!A2:D999,4,FALSE)

HTH
Frank
 
HI, yea it works but im still having the same problem with repeatin
product numbers, its just brings them up as errors.
I need it to look into the range of product numbers and match the on
in the repeated cell to it and produce the price of that product - a
the moment its just doing it while scrolling down the cells in th
sheets.....
Does this make sense to you?

Thanks for your help bt
 
Hi
I'm not sure I understand the layout of your spreadsheet. Maybe you can
post an example (in plain text - no attachment) with some cells and the
exspected result.
If you like you can mail me your sheet and I'll look into it
Frank
 
hi

yea can i post you my workbook - i need ur email address though - i
replyin via a forum and I cant access ur emai
 
Back
Top