Search results

What I hope to achieve is to find out the values of those missing cases #N/A N/A. For example, in the 4th case, it is "Low" for the case 2770. Therefor, the first two cases (both with 2770) should also be "Low", not #N/A N/A. This needs some INDEX/MATCH combinations, I believe, to look up...

Hi, I have the data below. I want to use available data to replace missing values. For example, the case 2770 appear 3 times, and all of them should have a value of "Low", but it shows #N/A N/A in the first two cases. How can I use formula to achieve this goal? 2770 #N/A N/A 2770 #N/A N/A...

Hi Sir, I have a file 'Master' which needs to fetch data from three columns of file 'Source'. Currently it is simply specified as linking to A1, B1 ... What worries me is that if someone inserted new columns in the source file, the data fetched are wrong! Can I ask how to use some formula...

Hi, SirJB7, I'm really grateful and feeling impressed with your solution. I've kept it to myself and learn from it. Thanks so much. Of course, if some members here can provide a simple non-VBA solution, that will be helpful as well.

Narayan, how is it going now?

Narayan, thanks for your suggestion. Sure you can do it :)

Hi Narayan, the range can be set to be Sheet!A1:K100. I'm very excited to see how this will be resolved, as I asked my friends and none of them is capable of doing it.

Hi Narayan, I would not try to use VBA in my case. Only some Excel is useful to my case. Are you able to get it work?

Hi, Narayan, This is absolutely right. To make it slightly easy, 2. the file name of the workbook is given as Sheet1. If you can get this work, this is really amazing to me and most Excel users. Not sure how you will post the answer as it seems that this forum has no room to upload Excel...

It is not ideal to copy and paste in my case. The sheet is too big and I simply want to get 10 cells of data.

Hi, It's been interesting to me on how to read data selectively from the other workbook. Rather than pull all data, I just want to read values of 10 cells: the 1st cell has a unique name "ID code", and from this cell downward to the 10th cell. Though this seems to be easy, I cannot get this...