Nested IF problem

[safisana]

When D01 Is typed in cell A8 i want the price for D01 from the Rate sheet K24 to be automatically inserted into Pricing sheet E8
Whatever code is inserted D01-D100 in column A should automatically fill the appropriate price from rate sheet column K into column E

They are both sheets in the same workbook

 

[earthworm]

U need to create similarity between the values you input along with values present in table .
try vlookup

 

[ukmikeb]

Duplicate of http://www.mrexcel.com/forum/excel-questions/808972-nested-if-problem.html

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #9 of the Forum Rules.

Any bumps, clarifications, or follow-ups should be posted to the thread linked by Mike.