Emoncada
11-26-2008, 10:33 AM
I would like something like this.
I want this
If Column B = "NC8440" and Column F = "Keyboard" then Column G = "**The Formula**"
So I have a worksheet ("Spare Parts") that has column headers.
all in row 3.
So it will be something like this.
Column.............A..............B..............C............D............ .E..............F
Row3....................NC8440....................NC8500................... DC7700...
Row4...........Keyboard.......401.....Keyboard......921........Keyboard.... 192
Row5...........Touchpad......498.....Touchpad.....843........Touchpad....18 8
Row6...........Battery.........466......Battery.......882.........Display.. .....109
Basically ("Spare Parts") looks something like this.
So I need for it to look for a match in row 3 then look under that and find a match with ("Orders")Column F.
example
If ("Orders") Cell B5 = "NC8440" and Cell F5 = "Touchpad"
Then Cell G5 = "498"
If ("Orders") Cell B6 = "DC7700" and Cell F6 = "Display"
Then Cell G6 = "109"
Hope that isn't too comfusing.
I want this
If Column B = "NC8440" and Column F = "Keyboard" then Column G = "**The Formula**"
So I have a worksheet ("Spare Parts") that has column headers.
all in row 3.
So it will be something like this.
Column.............A..............B..............C............D............ .E..............F
Row3....................NC8440....................NC8500................... DC7700...
Row4...........Keyboard.......401.....Keyboard......921........Keyboard.... 192
Row5...........Touchpad......498.....Touchpad.....843........Touchpad....18 8
Row6...........Battery.........466......Battery.......882.........Display.. .....109
Basically ("Spare Parts") looks something like this.
So I need for it to look for a match in row 3 then look under that and find a match with ("Orders")Column F.
example
If ("Orders") Cell B5 = "NC8440" and Cell F5 = "Touchpad"
Then Cell G5 = "498"
If ("Orders") Cell B6 = "DC7700" and Cell F6 = "Display"
Then Cell G6 = "109"
Hope that isn't too comfusing.