taking values from sheet 1 to read sheet 2 and input data on sheet 3 in that order
hi, I have 3 worksheets [data sheet, info sheet, quotation sheet],
question - on the data sheet, say on B5, I say "High", I want to read from info sheet the price for "High" to be placed on the quotation sheet.
[so, if I say Low on B5 on data sheet, the quotation page should reflect the price of low from the info sheet.
how do i do this?
thanks in advance.
yikes,
i still don't understand.
if i am not using VBA but normal excel, can this be done?
Last edited by asshekin; 04-03-2011 at 11:47 PM.
Suggest you post your worksheets with dummy data so that we can better understand your issue and give you a viable solution. Suggest you show your expected results also. This will give us all the data needed to help you.
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Maybe you could try vlookup function. This will be the example code to be copied on the quotation sheet:
Please Login or Register to view this content.
Info sheet should contain the corresponding values for "high and low".
Hope that it helped you.
i.e. i have 3 sheets
sheet 1 - Cell A1 = Low
Sheet 2
Cell A1 - Low - [B1] 1000
Cell A2 - Medium - [B2] 1500
Cell A3 - High - [B3] 2000
Sheet 3 - Cell A1 = 1000
[this is what i am trying to figure out, because in sheet 1 cell A1, i may select medium or high and I need the value in cell A1 in sheet 3 to reflect the values according to the level.
i hope this helps.
i dont know how to post my worksheet.
Vlookup function is suitable for your problem. Download this file for an example.
Please Login or Register to view this content.
nice. vlookup works. thanks!
curious.. how did you do the drop down list without using developer form control?
Regarding the drop-down list, select your target cell or range then go to Data > Data Validation > Settings > Allow_List
then find your source data or input the desired data separated by comma.
See attached screenshot.
Last edited by batman07; 04-05-2011 at 10:14 PM.
Hi asshekin
welcome to the forum
You acn use
Please Login or Register to view this content.
that is great batman, Thanks!!
thanks pike! index function works too!
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks