Help with nesting VLookup into an IF function

[gloess1]

Hi guys. I've been trying to figure this out but haven't been able to. Here's my equation now
=IF('URD Take Off'!$D1='URD Summary'!$B:$B,VLOOKUP('URD Take Off'!$A2,'URD Summary'!$B$5:$M$2462,10,FALSE),0)

Essentially I am trying to say if the vendor name (cell d1) exists in row B in my reference table then it looks up the price (column 10 of reference table) of the unit (cell A2 in my current sheet). Can this be done?

 

[oldbrewer]

Hi guys. I've been trying to figure this out but haven't been able to. Here's my equation now

=IF('URD Take Off'!$D1='URD Summary'!$B:$B,VLOOKUP('URD Take Off'!$A2,'URD Summary'!$B$5:$M$2462,10,FALSE),0)

Essentially I am trying to say if the vendor name (cell d1) exists in row B in my reference table then it looks up the price (column 10 of reference table) of the unit (cell A2 in my current sheet). Can this be done?

name2

unit6

67

name4

unit3

no name

name1

unit9

85

name1

unit1

37

name2

unit2

43

name3

unit3

49

unit4

55

unit5

61

unit6

67

unit7

73

unit8

79

unit9

85

unit10

91

67 obtained by

=IF(ISERROR(OFFSET($H$9,MATCH(C7,$H$10:$H$12,0),0)),"no name",OFFSET($L$9,MATCH(D7,$L$10:$L$19,0),1))

<colgroup><col span="19"></colgroup><tbody>
</tbody>

 

[oldbrewer]

scroll right to see the unit table

easy to add sheet name references in the formula - this is the basic methodology

 

[gloess1]

Hi guys. I've been trying to figure this out but haven't been able to. Here's my equation now

=IF('URD Take Off'!$D1='URD Summary'!$B:$B,VLOOKUP('URD Take Off'!$A2,'URD Summary'!$B$5:$M$2462,10,FALSE),0)

Essentially I am trying to say if the vendor name (cell d1) exists in row B in my reference table then it looks up the price (column 10 of reference table) of the unit (cell A2 in my current sheet). Can this be done?

name2

unit6

67

name4

unit3

no name

name1

unit9

85

name1

unit1

37

name2

unit2

43

name3

unit3

49

unit4

55

unit5

61

unit6

67

unit7

73

unit8

79

unit9

85

unit10

91

67 obtained by

=IF(ISERROR(OFFSET($H$9,MATCH(C7,$H$10:$H$12,0),0)),"no name",OFFSET($L$9,MATCH(D7,$L$10:$L$19,0),1))

<tbody>
</tbody>

Thank you! I actually got it to work by using =VLOOKUP($D1&$A2,'URD Summary'!$D$5:$M$2462,8,FALSE) because that concatenate value was already in the reference table. Oops!