Forum Discussion
Use formula in a second file to obtain values in multiple cells in first file
I'd like to be able to get a value in a cell based on the value in another cell using the formula in another sheet/file - multiple times in the first sheet. By way of simple example - let's say t...
mathetes thanks for your reply!
OK ... I'm starting to see how this might work, though I don't think I properly understand the syntax of the LAMBDA function just yet
(I should hopefully be able to work within 1 workbook with multiple sheets, by importing the data from the other workbook)
See example file - in Sheet1, I want to be able to put the values in column 2 and get the responses in column 3, by reference to the formula in B3 of Sheet2 (i.e. as though B2 of Sheet2 contained the relevant value in column 2 of Sheet2)
i.e. without putting the formula itself in the LAMBDA function (because in the real thing the formula is very complex)
Is this possible??
EDIT - forum doesn't allow uploading files - here's the Sheets
Sheet1
| ENTER VALUE | ANSWER | |
| 1 | =LAMBDA(Sheet2!B3, Sheet2!B2)(B2) | |
| 2 | ||
| 3 |
Sheet2
| FORMULA INPUT | |
| FORMULA OUTPUT | =B2*2 |
You can put a copy of your file, including the complicated formula, on OneDrive or GoogleDrive, and then post a link here that grants others access. Let's do that.