Nested IF problem

Status
Not open for further replies.

safisana

New Member
Joined
Oct 1, 2014
Messages
8
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
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

earthworm

Active Member
Joined
May 19, 2009
Messages
347
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
U need to create similarity between the values you input along with values present in table .
try vlookup
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,165
Office Version
  1. 365
Platform
  1. Windows
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,108,630
Messages
5,523,991
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top